package com.topisv.tms.repository;

import java.util.List;

import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.data.repository.PagingAndSortingRepository;

import com.topisv.tms.entity.CustomersOrdenoSource;

public interface CustomersOrdenoSourceDao extends JpaSpecificationExecutor<CustomersOrdenoSource>, PagingAndSortingRepository<CustomersOrdenoSource, Long> {

	List<CustomersOrdenoSource> findByCustomerCode(String customerCode);
	@Query("select t from CustomersOrdenoSource t where t.customerCode=? and status='1'")
	List<CustomersOrdenoSource> findByCustomerCode2(String customerCode);
}
